package com.company;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

/**
 * @description:
 * @author: ZhaoYicong
 * @date: Created in 2020/7/10 15:34
 * @version: v1.0
 * @modified By:
 */
public interface StudentDAO {
    //插入信息
    void insertdata(Connection connection, Student student) throws SQLException;

    //查询信息
    //所有信息
    List<Student> searchall(Connection connection) throws SQLException;

    Student searchbyID(Connection connection,int id) throws SQLException;
    List<Student> searchbyName(Connection connection,String s) throws SQLException;
    List<Student> searchbychineses(Connection connection,int cs) throws SQLException;
    List<Student> searchbymaths(Connection connection,int ms) throws SQLException;
    List<Student> searchbyengliss(Connection connection,int es) throws SQLException;
    Student searchbySId(Connection connection,int sid) throws SQLException;


    void updata(Connection connection, Student student) throws SQLException;

    void deleteData(Connection connection,int id) throws SQLException;



}
